CREATE procedure [dbo].[BAECompanySearch]
    @CompanyName AS varchar(80),    
    @MemberType AS varchar(2500)
AS
    SET @CompanyName = UPPER(@CompanyName)
    IF LEN(@MemberType) > 0
    BEGIN
        SELECT *
          FROM [dbo].[Name]
         WHERE [COMPANY_RECORD] = 1
               AND [MEMBER_TYPE] IN (SELECT * FROM [dbo].[GetValueListTable](@MemberType))
               AND UPPER([COMPANY]) LIKE '%' + @CompanyName + '%'
         ORDER BY [COMPANY]
    END
    ELSE
    BEGIN
        SELECT *
          FROM [dbo].[Name]
         WHERE [COMPANY_RECORD] = 1
               AND UPPER([COMPANY]) LIKE '%' + @CompanyName + '%'
         ORDER BY [COMPANY]
    END

GO